package com.sp.service;

import com.sp.pojo.SpReePlatform;

import org.springframework.web.multipart.MultipartFile;
import com.sp.result.Pager;
import com.sp.result.Result;
import java.util.List;


public interface SpReePlatformService{
/**
*增加数据
**/
int insertSpReePlatform(SpReePlatform record)throws Exception;

    /**
    *删除数据
    **/
    int deleteSpReePlatformByPrimaryKey( Integer spReePlatformId )throws Exception;

    /**
    * 通过主键删除多条数据
    **/
    int deleteSpReePlatformByIds( String [] spReePlatformIds)throws Exception;


    /**
    * 更新数据
    **/
    int updateSpReePlatformByPrimaryKey(SpReePlatform record)throws Exception;
    /**
    * 批量更新属性不为空数据
    **/
        int updateSpReePlatformByPrimaryKeyNotNull(SpReePlatform record,String[] spReePlatformIds) throws Exception;

    /**
    * 通过主键查询数据
    **/
    SpReePlatform selectSpReePlatformByPrimaryKey( Integer spReePlatformId );


/**
* 通过条件查询数据
**/
List<SpReePlatform> selectSpReePlatform(SpReePlatform spReePlatform  , String desc, String startTime, String endTime, String notNullAttributes,
String isNullAttributes, String globalSearch,String likeNameSearch, Double amountSearch,
String universalTime,String multipleChoiceCondition, String fieldConditionStr);

/**
*总条数
**/
long getSpReePlatformPageCount(SpReePlatform spReePlatform, String desc, String startTime, String endTime, String notNullAttributes,
String isNullAttributes, String globalSearch,String likeNameSearch, Double amountSearch, String universalTime,String multipleChoiceCondition, String fieldConditionStr);
/**
* 分页条件查询
**/
Pager<SpReePlatform> getSpReePlatformPage(long curPage, int pageSize, String orderBy, SpReePlatform spReePlatform, String desc, String startTime, String endTime, String notNullAttributes,
String isNullAttributes, String globalSearch,String likeNameSearch, Double amountSearch, String universalTime,String multipleChoiceCondition, String fieldConditionStr,String isLimit);
/**
* 导出模板
*
* @throws Exception
*/
void exportSpSupplierTemplate() throws Exception;


/**
* 导出供应商
* @param orderBy 以什么排序
* @param spReePlatform
* @param desc 是否降序排序
* @param startTime 开始时间
* @param endTime 结束时间
* @param notNullAttributes 不为空筛选  多个,分割
* @param isNullAttributes 为空筛选 多个
* @param globalSearch
* @param likeNameSearch 模糊查询 格式 {字段:'条件'}
* @param amountSearch 数值模糊查询
* @param universalTime 时间 格式 {字段:{startTime:'',endTime:''}}
* @param multipleChoiceCondition 多选条件格式 {字段:[数据,数据]}
* @param fieldConditionStr 高级查询json 格式[{databaseId:'',relationId:'',datas:[]}]
* @throws Exception
*/

 void exportSpSupplier(String orderBy, SpReePlatform spReePlatform, String desc, String startTime, String endTime, String notNullAttributes, String isNullAttributes, String globalSearch, String likeNameSearch, Double amountSearch, String universalTime, String multipleChoiceCondition, String fieldConditionStr) throws Exception ;

/**
* 导入供应商数据
*
* @param file
* @throws Exception
*/

 void importSpReePlatform(MultipartFile file) throws Exception;
}